package cn.edu.lzu.dao;

import cn.edu.lzu.entity.FillSupItem;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * @PackageName: cn.edu.lzu.dao
 * @InterfaceName: FillSupItemMapper
 * @Description: TODO
 * @Author: 张琦[QQ:3098086691]
 * @Date: 2020/4/8 16:15
 * @Version: 1.0
 */
@Mapper
public interface FillSupItemMapper {
    @Select("select * from fill_sup_item where is_deleted=0 and book_registe_id=#{bookRegisteId} and examine_item_id=#{examineItemId}")
    FillSupItem selRecordByBookIdAndItemId(int bookRegisteId, int examineItemId);


    @Insert("insert into fill_sup_item (fill_sup_item_id, book_registe_id, examine_item_id, is_deleted, is_filled) values(default, #{bookRegisteId}, #{examineItemId}, 0, 0)")
    int insFillSupItem(int bookRegisteId, int examineItemId);
}
